/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1411

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|00000010| 43 41 44 45 00 20 20 2d | 2d 20 45 52 77 69 6e 20 |CADE.  -|- ERwin |
|00000020| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00000030| 65 0d 0a 20 20 2d 2d 20 | 25 50 61 72 65 6e 74 20 |e..  -- |%Parent |
|00000040| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00000050| 6c 64 20 4f 4e 20 43 48 | 49 4c 44 20 55 50 44 41 |ld ON CH|ILD UPDA|
|00000060| 54 45 20 43 41 53 43 41 | 44 45 20 0d 0a 20 20 77 |TE CASCA|DE ..  w|
|00000070| 68 65 6e 0d 0a 20 20 20 | 20 2d 2d 20 25 25 4a 6f |hen..   | -- %%Jo|
|00000080| 69 6e 50 4b 50 4b 28 6f | 6c 64 72 6f 77 73 2c 6e |inPKPK(o|ldrows,n|
|00000090| 65 77 72 6f 77 73 2c 22 | 20 3c 3e 20 22 2c 22 20 |ewrows,"| <> "," |
|000000a0| 6f 72 22 29 20 0d 0a 20 | 20 20 20 25 4a 6f 69 6e |or") .. |   %Join|
|000000b0| 50 4b 50 4b 28 6f 6c 64 | 72 6f 77 73 2c 6e 65 77 |PKPK(old|rows,new|
|000000c0| 72 6f 77 73 2c 22 20 3c | 3e 20 22 2c 22 20 6f 72 |rows," <|> "," or|
|000000d0| 22 29 0d 0a 20 20 20 20 | 20 20 28 69 6e 73 65 72 |")..    |  (inser|
|000000e0| 74 20 69 6e 74 6f 20 25 | 50 61 72 65 6e 74 20 28 |t into %|Parent (|
|000000f0| 25 50 61 72 65 6e 74 50 | 4b 28 22 2c 22 2c 29 29 |%ParentP|K(",",))|
|00000100| 0d 0a 20 20 20 20 20 20 | 20 20 73 65 6c 65 63 74 |..      |  select|
|00000110| 20 25 43 68 69 6c 64 46 | 4b 28 22 2c 22 2c 29 0d | %ChildF|K(",",).|
|00000120| 0a 20 20 20 20 20 20 20 | 20 20 20 66 72 6f 6d 20 |.       |   from |
|00000130| 6e 65 77 72 6f 77 73 0d | 0a 20 20 20 20 20 20 20 |newrows.|.       |
|00000140| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|00000150| 20 20 20 20 20 20 2d 2d | 20 25 25 4e 6f 74 6e 75 |      --| %%Notnu|
|00000160| 6c 6c 46 4b 28 6e 65 77 | 72 6f 77 73 2c 22 20 69 |llFK(new|rows," i|
|00000170| 73 20 6e 6f 74 20 6e 75 | 6c 6c 20 61 6e 64 22 29 |s not nu|ll and")|
|00000180| 20 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 25 | ..     |       %|
|00000190| 4e 6f 74 6e 75 6c 6c 46 | 4b 28 6e 65 77 72 6f 77 |NotnullF|K(newrow|
|000001a0| 73 2c 22 20 69 73 20 6e | 6f 74 20 6e 75 6c 6c 20 |s," is n|ot null |
|000001b0| 61 6e 64 22 29 0d 0a 20 | 20 20 20 20 20 20 20 20 |and").. |        |
|000001c0| 20 20 20 6e 6f 74 20 65 | 78 69 73 74 73 20 28 0d |   not e|xists (.|
|000001d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 73 |.       |       s|
|000001e0| 65 6c 65 63 74 20 2a 20 | 66 72 6f 6d 20 25 50 61 |elect * |from %Pa|
|000001f0| 72 65 6e 74 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |rent..  |        |
|00000200| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 |      wh|ere..   |
|00000210| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 2d |        |       -|
|00000220| 2d 20 25 25 4a 6f 69 6e | 46 4b 50 4b 28 6e 65 77 |- %%Join|FKPK(new|
|00000230| 72 6f 77 73 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |rows,%Pa|rent," =|
|00000240| 20 22 2c 22 20 61 6e 64 | 22 29 20 0d 0a 20 20 20 | "," and|") ..   |
|00000250| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 25 |        |       %|
|00000260| 4a 6f 69 6e 46 4b 50 4b | 28 6e 65 77 72 6f 77 73 |JoinFKPK|(newrows|
|00000270| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|00000280| 20 61 6e 64 22 29 0d 0a | 20 20 20 20 20 20 20 20 | and")..|        |
|00000290| 20 20 20 20 29 0d 0a 20 | 20 20 20 20 20 29 20 66 |    ).. |     ) f|
|000002a0| 6f 72 20 65 61 63 68 20 | 72 6f 77 0d 0a 00 1d 27 |or each |row....'|
+--------+-------------------------+-------------------------+--------+--------+